<?xml version="1.0" encoding="utf-8" ?> 
<!-- Description         :  The description/title of the stored procedure
      RestrictedTo        :  Will only show as an option to the corresponding users
                                "9" - Available to everyone
      StoredProcedureName :  The name of the stored procedure 
      UseXSLTFile        :  true/false - If true a file with the same name needs to exist in the folder with extension xslt.
     
      
      Notes  1. Passing userId - To pass the user id logged in the application to the stored procedure 
                                         create a parameter of userId in the stored procedure.  You do not have 
      -->
<report Description="Financial Activity Report" LongDescription="Financial Activity Report."  RestrictedTo="524288" StoredProcedureName="" ReportingServicesReportName="FinancialActivityReport" UseXSLTFile="false">
<!-- Enter one or multiple textcriteria nodes.  One for each parameter that the stored procedure expects
      ParameterName :  The name of the stored proc parameter.  
      Description   :  The description to be displayed to the user.
      Type          :  The type of input expected
                          "text" - For free form text
                          "date" - Date value
                           "phone" - Phone number in the format xxx-xxx-xxxx
                           "zipCode" - US zip code
                           "email" - Email
                           "integernumber" - Integer number
                           "decimalnumber" - Decimal number
      IsRequired    :  true/false - If an input is required for this parameter  
      DefaultValue  :  Default value         
      IsVisible     :  true/false to ask the user for input      
     <textcriteria Description="Employee Id" ParameterName="EmployeeID" Type="integernumber" IsRequired="true" DefaultValue="" IsVisible="false"  />-->
     <!-- <textcriteria Description="StartDate" ParameterName="StartDate" IsVisible="true" IsRequired="true" type="date"/>-->

     <!-- Enter one or multiple dropdowncriteria nodes.  One for each parameter that the stored procedure expects
      ParameterName :  The name of the stored proc parameter that corresponds to the dropdown.  
      Description   :  The description to be displayed to the user next to the dropdown.
      PopulateFrom  :  The stored procedure name that populates this dropdown.
      ValueColumn   :  The name of the column that should be used as the value column.
      TextColumn    :  The name of the column that should be used as the text column.
      IsRequired    :  true/false - If an input is required  
      DefaultValue  :  The id to be selected by default - Leave blank for no selection

     <dropdowncriteria Description="Company Id" ParameterName="companyId" PopulateFrom="oRetrieveCompanies" ValueColumn="CompanyId" TextColumn="CompanyName" IsRequired="true" DefaultValue="1"  />
-->
	<textcriteria Description="DomainUserId" ParameterName="DomainUserId" IsVisible="false" IsRequired="false" Type="text"/>
	<textcriteria Description="Processed Date (From)(*)" ParameterName="StartDate" IsVisible="true" IsRequired="true" Type="date"/>
	<textcriteria Description="Processed Date (To)(*)" ParameterName="EndDate" IsVisible="true" IsRequired="true" Type="date"/>

	<dropdowncriteria Description="Institution" ParameterName="Institution" PopulateFrom="GetInstitutions" ValueColumn="InstitutionId" TextColumn="Description" IsRequired="true" DisplayAllChoice="true"/>
	<listboxcriteria Height="100" SelectionMode="Single" Description="Department" ParameterName="Department" PopulateFrom="GetDepartments" ValueColumn="DeptId" TextColumn="DepartmentChiefCode" IsRequired="false" DisplayAllChoice="true" DependsOnControlParameterName="Institution" DefaultValue=""/>
	<listboxcriteria Height="100" SelectionMode="Multi" Description="Unit" ParameterName="Unit" PopulateFrom="GetUnits" ValueColumn="UnitId" TextColumn="Unit" IsRequired="false" DisplayAllChoice="true" DependsOnControlParameterName="Department" DefaultValue="0"  />

	<textcriteria Description="Fund #s (separate by commas)" ParameterName="FundNumber" IsVisible="true" IsRequired="false" Type="text"/>
	<listboxcriteria Height="100" SelectionMode="Single" Description="Principal Investigator" ParameterName="PrincipalInvestigator" PopulateFrom="GetPrincipalInvestigators" ValueColumn="PIId" TextColumn="PIName" IsRequired="false" DisplayAllChoice="true" DependsOnControlParameterName="Institution" DefaultValue="0" SearchParameterName="Name" />
	<listboxcriteria Height="100" SelectionMode="Single" Description="Sponsor" ParameterName="Sponsor" PopulateFrom="GetRptSponsors" ValueColumn="SponsorId" TextColumn="ShortName" IsRequired="false" DisplayAllChoice="true" DefaultValue="0" SearchParameterName="Name" />
	<listboxcriteria Height="100" SelectionMode="Single" Description="Originating Sponsor" ParameterName="OriginatingSponsor" PopulateFrom="GetSecondarySponsors" ValueColumn="Name" TextColumn="Name" IsRequired="false" DisplayAllChoice="true" DefaultValue="0" SearchParameterName="Name" />
	
	<listboxcriteria Height="100" SelectionMode="Single" Description="RM Staff Member" ParameterName="SubcontractSpecialist" PopulateFrom="GetSubContractSpecialists" ValueColumn="SubContractSpecialist" TextColumn="SubContractSpecialist" IsRequired="false" DependsOnControlParameterName="Institution" DisplayAllChoice="true" DefaultValue="0" SearchParameterName="Name" />
	<listboxcriteria Height="100" SelectionMode="Multi" Description="Deliverable Status" ParameterName="DeliverableStatus" PopulateFrom="GetDeliverableStatusesForFinance" ValueColumn="DELSTAT" TextColumn="DELSTATDESC" IsRequired="true" DisplayAllChoice="false" DefaultValue="ALL" />

	<dropdowncriteria Description="Group By" ParameterName="GroupBy" PopulateFrom="GetSubContractGroupByCodes" PopulateFromStaticParamValues="Report=RptSubContractWrapperReport,IncludeSubContr=NO"  ValueColumn="GroupByCode" TextColumn="GroupByName" IsRequired="true" DisplayAllChoice="false" DefaultValue="ORG"/>

</report>